package com.campus_assistant.mapper.db1;

import com.campus_assistant.pojo.db1.Scores;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface ScoresMapper {
    int addScores(Scores scores);
    int deleteScores(@Param("sid")int sid,@Param("cid")int cid);
    int updateScores(Scores scores);
    List<Scores> selectAll();
    List<Scores> getScoreBysId(int sId);//通过sId查询成绩
    String getCourseNameBycId(int cId);//通过cId查询课程名称
    List<Integer> getAllSid();//查询所有的sid
    List<Integer> getCidBySid(int sId);//通过sid查询cid
}
